Home

Computer science

'

\ufeffMake ERD and GRD a courier moving company. the relationships of the project are as under.
Customer (customer_id{P.K}, \ufeffFirst_name, Last_name, Contact, Address, Email)
Driver (Driver_id {P.K}, \ufeffFirst_name, Last_name, Contact, Address, Rating, Vehicle_type)
Active_Job (Job_id {P.K}, \ufeffCustomer_id{F.K}, \ufeffPick_up, \ufeffDrop_off, Vehicle_preference)
Bidding (Bid_id{P.K}, \ufeffJob_id{F.K}, \ufeffDriver_id{F.K}, \ufeffFare, Status)
Assigned_Job (Job_id{F.K}, \ufeffDriver_id{F.K})
Past_trip (Job_id{F.K}, \ufeffStatus, Time_appointed, Time completed)
First 2 \ufeffTables are basic. Active job is posted by the user with cutomer id a foreign key. user sets the vehicle preference from truck, UTE, Car, Bike, Van. from BIDDING table only those driver bid whose Vehicle_type (Driver table) = \ufeffVehicle_preference(Active_Job). \ufeffStatus in bidding table is weather the customer accepts the big or not.
Assigned_job table has Job_id and Driver Id both as foreign Key and job is assigned to the driver whose Status (bidding_table) = \ufeffAccepted.
Past_trip stores history of the trip. it saves the time started of a trip and time completed. and status weather it is completed or cancelled.
ERD should look something like the sample picture as under.



'

Answer